UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MeeG33fW9Cp5tMUCN46BLnWCwdw0siCuXOcm3mBplA0='
WHERE
key_id = '460ac09c65a9954425f095b44a83b232ebe6d0c7db5437ea792768388ccd45ed'
AND (
token = 'MeeG33fW9Cp5tMUCN46BLnWCwdw0siCuXOcm3mBplA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)