UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9hcaZhZ3Jza9xtbwcYWESP8OVNeP3Wgz2RiNPOa1rs='
WHERE
key_id = '1db4db1c46a1a3219396dd267db7e931809795cb60a16832bc0fe09632e38373'
AND (
token = 'p9hcaZhZ3Jza9xtbwcYWESP8OVNeP3Wgz2RiNPOa1rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)