UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWYTy0cyjMTQt1CrntLOP6fesMWb5OjsgU1bt/zo7yM='
WHERE
key_id = 'e346620a482f9d8d803a7df3655211f6a2212c3815b61481ab1a81ba8713510c'
AND (
token = 'bWYTy0cyjMTQt1CrntLOP6fesMWb5OjsgU1bt/zo7yM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)