UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8odXpOo+oGacR8K5v3r4HUmDvzoNtWPSBvLtBEi/eQc='
WHERE
key_id = '9c6c3a6207ab46bc643340911d1e68a2db5971b02bb310f88aa33ff0ddc70ee8'
AND (
token = '8odXpOo+oGacR8K5v3r4HUmDvzoNtWPSBvLtBEi/eQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)