UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiZsHoQF5HnB2MsMmdT1ZPuLu5hkLhuXheGqbn2xEvo='
WHERE
key_id = '132788ee50b160ace0ef8994e9bc7f8e0eaffd1aa6943f68c46d25374e9ec98f'
AND (
token = 'GiZsHoQF5HnB2MsMmdT1ZPuLu5hkLhuXheGqbn2xEvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)