UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ch6rjcLCWSB/R7nCpj0aUGwOGBk1IuSUwFnq6yO5iUc='
WHERE
key_id = 'dd3671c4e75f6045e07ec28030d69c28770f49b734e946695cd60e8ef8b5e500'
AND (
token = 'ch6rjcLCWSB/R7nCpj0aUGwOGBk1IuSUwFnq6yO5iUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)