UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fdnMnUQOcE9D7YUqZdUJpnM3CaeYy1+74ldUgs3faXg='
WHERE
key_id = '54f43d63fabbeab15b90213f8f6befc6c1e1161033957d8906ea61a80977cb72'
AND (
token = 'fdnMnUQOcE9D7YUqZdUJpnM3CaeYy1+74ldUgs3faXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)