UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cIXF0LR+3ajhsK2dKW0cCqWtJkcTLh/97ytPa94r4gs='
WHERE
key_id = '31399907d92ece8b010248cd3e1c2ef50d149bc6dd0a9b3b6045a26c8626a9e1'
AND (
token = 'cIXF0LR+3ajhsK2dKW0cCqWtJkcTLh/97ytPa94r4gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)