UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Ghz8ZYCvcTRsGwwygzm4pWNs4gEYMs0epp02CMU3qA='
WHERE
key_id = 'f8634a1b997c4c92f0506d3cb35501a816c536e48daa113d00dd23b084fb6dca'
AND (
token = '9Ghz8ZYCvcTRsGwwygzm4pWNs4gEYMs0epp02CMU3qA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)