UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p27v9zq2p4rc5bC01tXTv2BbLjfiopu/Td54UYZQGBs='
WHERE
key_id = '48c284faedf839b3955e79000fbb9f5fbea7a9f485c73d2aea41c6633514ce5b'
AND (
token = 'p27v9zq2p4rc5bC01tXTv2BbLjfiopu/Td54UYZQGBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)