UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cha1Hs7NZj+ZOkiRjJv0+TCBJJyEJTbsnoCg7kHqJ/4='
WHERE
key_id = '07b1b786f42d62a56b1be746974158ac2e585cc34f4c422c983a0b515bf1caf3'
AND (
token = 'cha1Hs7NZj+ZOkiRjJv0+TCBJJyEJTbsnoCg7kHqJ/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)