UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kg0WgDOAYqIEzhMGAJ9A8iE06nC2dgqbogNzmvtyiUA='
WHERE
key_id = 'a40e612a25c7fbd8336ac1755747276894d54b539b3bc8aec17dc914d5745b8c'
AND (
token = 'Kg0WgDOAYqIEzhMGAJ9A8iE06nC2dgqbogNzmvtyiUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)