UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dsqUXcp5NmOc05qvYe7NERWFuiDewe+xx6h0Uk6qsF8='
WHERE
key_id = 'ef8d6687947c2e5911db69670c84ddf93fc4b5f130150fa1dec2f8ed705c7aa1'
AND (
token = 'dsqUXcp5NmOc05qvYe7NERWFuiDewe+xx6h0Uk6qsF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)