UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ScX9gajPjRJS9UY2CqUsQK7ye1nuyW/VCgfPKXGIt8Y='
WHERE
key_id = '8ca43ba0e18099a3df87a43fdd737747e2526e2a99fade80caf80484f30a7b39'
AND (
token = 'ScX9gajPjRJS9UY2CqUsQK7ye1nuyW/VCgfPKXGIt8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)