UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+gT19X+xP8yqGpi6JQHdLRYZyQb47W6Byu90Qv/93vU='
WHERE
key_id = 'bb23b6d486b240cf3ed3ea5d4597db0555287e0ae2afdf51f3ec4b6e02473f08'
AND (
token = '+gT19X+xP8yqGpi6JQHdLRYZyQb47W6Byu90Qv/93vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)