UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGGc7SKmMU8PC1RQd5B+y+aYB+FgFvA0xTfRLVVKpO4='
WHERE
key_id = 'e2c7d7d083278085395c63770eb9a3956961a2934fd69568c30912280b4e8bef'
AND (
token = 'tGGc7SKmMU8PC1RQd5B+y+aYB+FgFvA0xTfRLVVKpO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)