UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NK4y3UsJQcqK7AbpqeCGZkHIfiXn90FS+hcAu1HnMU='
WHERE
key_id = 'bb923febca5b797091dc8705cd5150fa9837619960fd025ca3262d132c5a3f9b'
AND (
token = '4NK4y3UsJQcqK7AbpqeCGZkHIfiXn90FS+hcAu1HnMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)