UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgfeyvlYRIt0ed26+cbXBruWzezSImBOHWBWfa2Dyyw='
WHERE
key_id = 'bfa2587abe90dd00478c14548cf310ddb0a8334d2781565e292c6f89725395a8'
AND (
token = 'XgfeyvlYRIt0ed26+cbXBruWzezSImBOHWBWfa2Dyyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)