UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xZroEy5f7YQpzGc651gK7yavw8ootqVLwr2cxeX0uM='
WHERE
key_id = '5b75818a65161d76324d093934643f68986f668968cf5269f742886deb5bb2be'
AND (
token = '/xZroEy5f7YQpzGc651gK7yavw8ootqVLwr2cxeX0uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)