UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lsM36Ml81msUPLhdxy/CriEeJ1BjY5hkm/GQlV5kQ4='
WHERE
key_id = 'bdcb2b6edfcc69749c270ed7afad26b79f55cf803a214711043f2d05a43932ee'
AND (
token = '3lsM36Ml81msUPLhdxy/CriEeJ1BjY5hkm/GQlV5kQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)