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