UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4bGjWIlLWWT3gtWFR+gg2H/F+2wvfuOJKVnWXtJxLeg='
WHERE
key_id = 'deb4914c4a11f57fdf238e7c4c15f79d488687dfff99d1e0572a5bc4ea660bcf'
AND (
token = '4bGjWIlLWWT3gtWFR+gg2H/F+2wvfuOJKVnWXtJxLeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)