UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bwo8Xfjli/nSXzfPCJJzwGXXVxAPldPRr2TSF8I1Ilk='
WHERE
key_id = 'fed9e98021ba7cf7f352e75a1377a7a295b1175d9c2b21d5566df50fdf985b0e'
AND (
token = 'Bwo8Xfjli/nSXzfPCJJzwGXXVxAPldPRr2TSF8I1Ilk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)