UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2gMU1jgksS+32ImXnFrXJj92dwz2Jv6SxCmnTp1Mkgg='
WHERE
key_id = 'c807506935c751a84881bdd3ee70cf1146a16e7dda367f3cae4b3074cedcc140'
AND (
token = '2gMU1jgksS+32ImXnFrXJj92dwz2Jv6SxCmnTp1Mkgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)