UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mE473rl07lWAhcRTSHGg1cy+TPup+ovWn19HymOJllI='
WHERE
key_id = '71a7863ee8af9a4ac5e978ccb994de8fe6d557a73b9a4faa317e90b4b9760906'
AND (
token = 'mE473rl07lWAhcRTSHGg1cy+TPup+ovWn19HymOJllI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)