UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qzKe1Ub3A2B7FhFSxXJ6KDC4Khtb8UODAjVXeosSwGE='
WHERE
key_id = '27ba995d7ea6a55c5a110f499d33f9c867af0548ddbf2fa144074b4c6fc01bf5'
AND (
token = 'qzKe1Ub3A2B7FhFSxXJ6KDC4Khtb8UODAjVXeosSwGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)