UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLmV0w/7Ghup4I6um2ZkbWNvxgoUfMFQ3CJEXCFqM1I='
WHERE
key_id = '7bdf6ebcc9752c7c693edd8d1df2edccaa2c00afdcbd90280b6f37101630f14a'
AND (
token = 'nLmV0w/7Ghup4I6um2ZkbWNvxgoUfMFQ3CJEXCFqM1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)