UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BG70pmgNqjzXCAQYMVi7TmWI1cgItnBUKIpfJxAX+K0='
WHERE
key_id = 'a5ecc8bc84d6fae8fcad172aeddf05d9e4b85de1cfbd3b9b0cbd4aff881b4418'
AND (
token = 'BG70pmgNqjzXCAQYMVi7TmWI1cgItnBUKIpfJxAX+K0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)