UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5dySms2G8d2b+rolApA27cbEnUUzzOQbV1OKpfH+3cU='
WHERE
key_id = '48de11f56ef7bec78a8a02b07430dd5d2af5675bcef1348d29702b1c4a780310'
AND (
token = '5dySms2G8d2b+rolApA27cbEnUUzzOQbV1OKpfH+3cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)