UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bp6nnbBmECEMR03cG13RMNNMhSYDKOumgRCCIyT6Xto='
WHERE
key_id = '27101453ffc3dc7996e3004122fb3dff09c1135e9f3900c625f483f2f481f1bb'
AND (
token = 'bp6nnbBmECEMR03cG13RMNNMhSYDKOumgRCCIyT6Xto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)