UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6eDR43m4AYZFnL9sE1Kv4mNJHpmT0VOC6dxxqjCAXw='
WHERE
key_id = '55786dd14612b04063317449492f2417072b4253b28a6e4033e3627874cc26d6'
AND (
token = 'B6eDR43m4AYZFnL9sE1Kv4mNJHpmT0VOC6dxxqjCAXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)