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